﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="details.aspx.vb" Inherits="SwissBiking.details" %>

<asp:Content ID="Content2" ContentPlaceHolderID="FeaturedContent" runat="server">
   
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="MainContent" runat="server">
    <form id="form1" runat="server">
     <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataKeyNames="ID" DataSourceID="SqlDataSource1" Height="50px" Width="125px" AllowPaging="True" CellPadding="4" ForeColor="#333333" GridLines="None">
        <AlternatingRowStyle BackColor="White" />
        <CommandRowStyle BackColor="#D1DDF1" Font-Bold="True" />
        <EditRowStyle BackColor="#2461BF" />
        <FieldHeaderStyle BackColor="#DEE8F5" Font-Bold="True" />
    <Fields>
        <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True" SortExpression="ID" />
        <asp:BoundField DataField="username" HeaderText="username" SortExpression="username" />
        <asp:BoundField DataField="password" HeaderText="password" SortExpression="password" />
        <asp:BoundField DataField="email" HeaderText="email" SortExpression="email" />
        <asp:BoundField DataField="sex" HeaderText="sex" SortExpression="sex" />
        <asp:BoundField DataField="location" HeaderText="location" SortExpression="location" />
        <asp:BoundField DataField="age" HeaderText="age" SortExpression="age" />
        <asp:BoundField DataField="favourite_thing" HeaderText="favourite_thing" SortExpression="favourite_thing" />
        <asp:BoundField DataField="bike" HeaderText="bike" SortExpression="bike" />
        <asp:BoundField DataField="channel" HeaderText="channel" SortExpression="channel" />
        <asp:BoundField DataField="tagline" HeaderText="tagline" SortExpression="tagline" />
        <asp:BoundField DataField="logged_in" HeaderText="logged_in" SortExpression="logged_in" />
        <asp:BoundField DataField="login_count" HeaderText="login_count" SortExpression="login_count" />
        <asp:BoundField DataField="rating" HeaderText="rating" SortExpression="rating" />
        <asp:CheckBoxField DataField="active" HeaderText="active" SortExpression="active" />
        <asp:BoundField DataField="level" HeaderText="level" SortExpression="level" />
        <asp:BoundField DataField="image" HeaderText="image" SortExpression="image" />
<asp:BoundField DataField="ID" HeaderText="ID" SortExpression="ID" InsertVisible="False" ReadOnly="True"></asp:BoundField>
<asp:BoundField DataField="username" HeaderText="username" SortExpression="username"></asp:BoundField>
<asp:BoundField DataField="password" HeaderText="password" SortExpression="password"></asp:BoundField>
        <asp:BoundField DataField="email" HeaderText="email" SortExpression="email" />
        <asp:BoundField DataField="sex" HeaderText="sex" SortExpression="sex" />
        <asp:BoundField DataField="location" HeaderText="location" SortExpression="location" />
        <asp:BoundField DataField="age" HeaderText="age" SortExpression="age" />
        <asp:BoundField DataField="favourite_thing" HeaderText="favourite_thing" SortExpression="favourite_thing" />
        <asp:BoundField DataField="bike" HeaderText="bike" SortExpression="bike" />
        <asp:BoundField DataField="channel" HeaderText="channel" SortExpression="channel" />
        <asp:BoundField DataField="tagline" HeaderText="tagline" SortExpression="tagline" />
        <asp:BoundField DataField="logged_in" HeaderText="logged_in" SortExpression="logged_in" />
        <asp:BoundField DataField="login_count" HeaderText="login_count" SortExpression="login_count" />
        <asp:BoundField DataField="rating" HeaderText="rating" SortExpression="rating" />
<asp:CheckBoxField DataField="active" HeaderText="active" SortExpression="active"></asp:CheckBoxField>
        <asp:ImageField DataImageUrlField="image" HeaderText="User profile Image">
            <ControlStyle Width="250px" />
        </asp:ImageField>
    </Fields>
        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
        <RowStyle BackColor="#EFF3FB" />
</asp:DetailsView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionStringx %>" ProviderName="<%$ ConnectionStrings:ConnectionStringx.ProviderName %>" SelectCommand="SELECT * FROM [users] WHERE ([ID] = ?)">
    <SelectParameters>
        <asp:QueryStringParameter DefaultValue="0" Name="ID" QueryStringField="id" Type="Int32" />
    </SelectParameters>
    </asp:SqlDataSource>
        </form>
</asp:Content>
